﻿    -- DROP FUNCTION "Get_Students"(VARCHAR);
    --DROP FUNCTION "Get_Student"(character varying);
    --DROP FUNCTION get_student(character varying) first.
    CREATE OR REPLACE FUNCTION get_student (name int) 
    RETURNS "Student"
    AS 
    $$
    /***************************************************************************************************
    **  Function:	public."Get_Student"
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Get student list
    **
    **  Parameters (1):
    **
    **      name    VARCHAR(128)    -
    **
    **  Return:
    **
    **      void
    **
    **  Sample call:
    **
    **      SELECT "Add_Institution"('test_institution'); 
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial prototype
    ** 
    **  Status:
    **
    **      Dev
    ** 
    ***************************************************************************************************/
    BEGIN
        SELECT * FROM public."Student";
    END;
    $$ LANGUAGE plpgsql;